package com.cjack.frenchexcel.model;

import com.sargeraswang.util.ExcelUtil.ExcelCell;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.LinkedHashMap;
import java.util.Map;

@Data
public class ConsumerBankStatementModel implements Serializable {
    //第0列是行号，不处理
    @ExcelCell(index = 1)
    private String dateDeDepense;//日期
    @ExcelCell(index = 2)
    private String carteIdentifiant;//卡号
    @ExcelCell(index = 3)
    private String cooperativeNumber;//合作商编号
    @ExcelCell(index = 4)
    private String monthYear;//月年
    @ExcelCell(index = 5)
    private String cooperativeName;//合作商名称
    @ExcelCell(index = 6)
    private BigDecimal debit;//正的金额
    @ExcelCell(index = 7)
    private BigDecimal credit;//负的金额

    public static Map<String,String> getColMap(){
        Map<String,String> map = new LinkedHashMap<>();
        map.put( "a", "DATE");//日期
        map.put( "b", "CODE BANQUE");//卡号
        map.put( "c", "NO. DE COMPTE");//合作商编号
        map.put( "d", "num piece");
        map.put( "e", "LIBELLE");//合作商
        map.put( "f", "DEBIT");//正的金额
        map.put( "g", "CREDIT");//负的金额
        return map;
    }
}
